﻿/*
This script was created by Visual Studio on 06/06/2008 at 15:48.
Run this script on asa\sqlexpress.DB_Deploy.dbo to make it the same as asa\sqlexpress.DBTims.dbo.
This script performs its actions in the following order:
1. Disable foreign-key constraints.
2. Perform DELETE commands. 
3. Perform UPDATE commands.
4. Perform INSERT commands.
5. Re-enable foreign-key constraints.
Please back up your target database before running this script.
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*Pointer used for text / image updates. This might not be needed, but is declared here just in case*/
DECLARE @pv binary(16)
BEGIN TRANSACTION
ALTER TABLE [dbo].[dtCity] DROP CONSTRAINT [FK_dtCity_dtCity]
SET IDENTITY_INSERT [dbo].[dtCity] ON
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (34, N'Таджикистан', NULL, 0, N'.34.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (35, N'Россия', NULL, 0, N'.35.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (36, N'р. Душанбе', 34, 1, N'.34.36.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (37, N'Душанбе', 36, 2, N'.34.36.37.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (38, N'Центральная Россия', 35, 1, N'.35.38.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (39, N'Москва', 38, 2, N'.35.38.39.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (40, N'Омск', 38, 2, N'.35.38.40.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (41, N'Халтонская', 34, 1, N'.34.41.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (42, N'Халтон', 41, 2, N'.34.41.42.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (43, N'Франция', NULL, 0, N'.43.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (44, N'Англия', NULL, 0, N'.44.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (45, N'Германия', NULL, 0, N'.45.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (46, N'США', NULL, 0, N'.46.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (47, N'Китай', NULL, 0, N'.47.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (48, N'Индия', NULL, 0, N'.48.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (49, N'Япония', NULL, 0, N'.49.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (50, N'Грузия', NULL, 0, N'.50.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (51, N'Канада', NULL, 0, N'.51.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (52, N'Польша', NULL, 0, N'.52.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (53, N'Больгария', NULL, 0, N'.53.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (54, N'Еспания', NULL, 0, N'.54.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (55, N'Турция', NULL, 0, N'.55.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (56, N'Азербаиджан', NULL, 0, N'.56.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (57, N'Дания', NULL, 0, N'.57.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (58, N'Чехия', NULL, 0, N'.58.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (59, N'Словения', NULL, 0, N'.59.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (60, N'Италия', NULL, 0, N'.60.')
INSERT INTO [dbo].[dtCity] ([CodeID], [hName], [mgrid], [hrclvl], [hrccrt]) VALUES (62, N'Бразилия', NULL, 0, N'.62.')
SET IDENTITY_INSERT [dbo].[dtCity] OFF
ALTER TABLE [dbo].[dtCity] ADD CONSTRAINT [FK_dtCity_dtCity] FOREIGN KEY ([mgrid]) REFERENCES [dbo].[dtCity] ([CodeID])
COMMIT TRANSACTION
